package org.jeecg.modules.aliyun.phone.control;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import lombok.extern.slf4j.Slf4j;
import org.apache.shiro.SecurityUtils;
import org.jeecg.common.api.vo.Result;
import org.jeecg.common.aspect.annotation.AutoLog;
import org.jeecg.common.system.query.QueryGenerator;
import org.jeecg.common.system.vo.LoginUser;
import org.jeecg.modules.gui.entity.GuiTestOrderCustom;
import org.jeecg.modules.gui.entity.GuiTestOrderMain;
import org.jeecg.modules.gui.service.IGuiTestOrderCustomService;
import org.jeecg.modules.gui.service.IGuiTestOrderMainService;
import org.jeecg.modules.gui.vo.GuiTestOrderMainPage;
import org.jeecgframework.poi.excel.ExcelImportUtil;
import org.jeecgframework.poi.excel.def.NormalExcelConstants;
import org.jeecgframework.poi.excel.entity.ExportParams;
import org.jeecgframework.poi.excel.entity.ImportParams;
import org.jeecgframework.poi.excel.view.JeecgEntityExcelView;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.multipart.MultipartHttpServletRequest;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.Map;

/**
* @Description: GUI订单管理
* @Author: jeecg-boot
* @Date:   2022-08-09
* @Version: V1.0
*/
@Api(tags="GUI订单管理")
@RestController
@RequestMapping("/ali/phone")
@Slf4j
public class PhoneController {
   @Autowired
   private IGuiTestOrderMainService guiTestOrderMainService;
   @Autowired
   private IGuiTestOrderCustomService guiTestOrderCustomService;


   /**
    * 分页列表查询
    *
    * @param guiTestOrderMain
    * @param pageNo
    * @param pageSize
    * @param req
    * @return
    */
   @AutoLog(value = "Test")
   @ApiOperation(value="Test", notes="Test")
   @GetMapping(value = "/test")
   public Result<?> queryPageList(GuiTestOrderMain guiTestOrderMain,
                                  @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
                                  @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
                                  HttpServletRequest req) {

       return Result.OK("pageList");
   }

   /**
    * 添加
    *
    * @param guiTestOrderMainPage
    * @return
    */
   @AutoLog(value = "GUI订单管理-添加")
   @ApiOperation(value="GUI订单管理-添加", notes="GUI订单管理-添加")
   @PostMapping(value = "/add")
   public Result<?> add(@RequestBody GuiTestOrderMainPage guiTestOrderMainPage) {
       GuiTestOrderMain guiTestOrderMain = new GuiTestOrderMain();
       BeanUtils.copyProperties(guiTestOrderMainPage, guiTestOrderMain);
       guiTestOrderMainService.saveMain(guiTestOrderMain, guiTestOrderMainPage.getGuiTestOrderCustomList());
       return Result.OK("添加成功!");
   }

   /**
    * 编辑
    *
    * @param guiTestOrderMainPage
    * @return
    */
   @AutoLog(value = "GUI订单管理-编辑")
   @ApiOperation(value="GUI订单管理-编辑", notes="GUI订单管理-编辑")
   @RequestMapping(value = "/edit", method = {RequestMethod.PUT,RequestMethod.POST})
   public Result<?> edit(@RequestBody GuiTestOrderMainPage guiTestOrderMainPage) {
       GuiTestOrderMain guiTestOrderMain = new GuiTestOrderMain();
       BeanUtils.copyProperties(guiTestOrderMainPage, guiTestOrderMain);
       guiTestOrderMainService.updateMain(guiTestOrderMain, guiTestOrderMainPage.getGuiTestOrderCustomList());
       return Result.OK("编辑成功!");
   }

   /**
    * 通过id删除
    *
    * @param id
    * @return
    */
   @AutoLog(value = "GUI订单管理-通过id删除")
   @ApiOperation(value="GUI订单管理-通过id删除", notes="GUI订单管理-通过id删除")
   @DeleteMapping(value = "/delete")
   public Result<?> delete(@RequestParam(name="id",required=true) String id) {
       guiTestOrderMainService.delMain(id);
       return Result.OK("删除成功!");
   }

   /**
    * 批量删除
    *
    * @param ids
    * @return
    */
   @AutoLog(value = "GUI订单管理-批量删除")
   @ApiOperation(value="GUI订单管理-批量删除", notes="GUI订单管理-批量删除")
   @DeleteMapping(value = "/deleteBatch")
   public Result<?> deleteBatch(@RequestParam(name="ids",required=true) String ids) {
       this.guiTestOrderMainService.delBatchMain(Arrays.asList(ids.split(",")));
       return Result.OK("批量删除成功！");
   }

   /**
    * 通过id查询
    *
    * @param id
    * @return
    */
   @AutoLog(value = "GUI订单管理-通过id查询")
   @ApiOperation(value="GUI订单管理-通过id查询", notes="GUI订单管理-通过id查询")
   @GetMapping(value = "/queryById")
   public Result<?> queryById(@RequestParam(name="id",required=true) String id) {
       GuiTestOrderMain guiTestOrderMain = guiTestOrderMainService.getById(id);
       return Result.OK(guiTestOrderMain);
   }

   /**
    * 通过id查询
    *
    * @param id
    * @return
    */
   @AutoLog(value = "客户明细-通过主表ID查询")
   @ApiOperation(value="客户明细-通过主表ID查询", notes="GUI订单管理-通过主表ID查询")
   @GetMapping(value = "/queryGuiTestOrderCustomByMainId")
   public Result<?> queryGuiTestOrderCustomListByMainId(@RequestParam(name="id",required=true) String id) {
       List<GuiTestOrderCustom> guiTestOrderCustomList = guiTestOrderCustomService.selectByMainId(id);
       return Result.OK(guiTestOrderCustomList);
   }

 /**
  * 导出excel
  *
  * @param request
  * @param guiTestOrderMain
  */
 @RequestMapping(value = "/exportXls")
 public ModelAndView exportXls(HttpServletRequest request, GuiTestOrderMain guiTestOrderMain) {
     // Step.1 组装查询条件
     QueryWrapper<GuiTestOrderMain> queryWrapper = QueryGenerator.initQueryWrapper(guiTestOrderMain, request.getParameterMap());
     LoginUser sysUser = (LoginUser) SecurityUtils.getSubject().getPrincipal();

     //Step.2 获取导出数据
     List<GuiTestOrderMainPage> pageList = new ArrayList<GuiTestOrderMainPage>();
     List<GuiTestOrderMain> guiTestOrderMainList = guiTestOrderMainService.list(queryWrapper);
     for (GuiTestOrderMain temp : guiTestOrderMainList) {
         GuiTestOrderMainPage vo = new GuiTestOrderMainPage();
         BeanUtils.copyProperties(temp, vo);
         List<GuiTestOrderCustom> guiTestOrderCustomList = guiTestOrderCustomService.selectByMainId(temp.getId());
         vo.setGuiTestOrderCustomList(guiTestOrderCustomList);
         pageList.add(vo);
     }
     //Step.3 调用AutoPoi导出Excel
     ModelAndView mv = new ModelAndView(new JeecgEntityExcelView());
     mv.addObject(NormalExcelConstants.FILE_NAME, "GUI订单管理");
     mv.addObject(NormalExcelConstants.CLASS, GuiTestOrderMainPage.class);
     mv.addObject(NormalExcelConstants.PARAMS, new ExportParams("GUI订单管理数据", "导出人:"+sysUser.getRealname(), "GUI订单管理"));
     mv.addObject(NormalExcelConstants.DATA_LIST, pageList);
     return mv;
 }

 /**
  * 通过excel导入数据
  *
  * @param request
  * @param response
  * @return
  */
 @RequestMapping(value = "/importExcel", method = RequestMethod.POST)
 public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) {
     MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
     Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
     for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
         MultipartFile file = entity.getValue();// 获取上传文件对象
         ImportParams params = new ImportParams();
         params.setTitleRows(2);
         params.setHeadRows(1);
         params.setNeedSave(true);
         try {
             List<GuiTestOrderMainPage> list = ExcelImportUtil.importExcel(file.getInputStream(), GuiTestOrderMainPage.class, params);
             for (GuiTestOrderMainPage page : list) {
                 GuiTestOrderMain po = new GuiTestOrderMain();
                 BeanUtils.copyProperties(page, po);
                 guiTestOrderMainService.saveMain(po, page.getGuiTestOrderCustomList());
             }
             return Result.OK("文件导入成功！数据行数:" + list.size());
         } catch (Exception e) {
             log.error(e.getMessage(),e);
             return Result.error("文件导入失败:"+e.getMessage());
         } finally {
             try {
                 file.getInputStream().close();
             } catch (IOException e) {
                 e.printStackTrace();
             }
         }
     }
     return Result.OK("文件导入失败！");
 }

}
